Permissions

The user specified in the endpoint settings must be granted access to the Netezza Performance Server (NPS) account as well as the privileges listed below.

Database privileges

LIST on <database> to <Replicate user>
SELECT on <database> to <Replicate user>

Table privileges

CREATE TABLE to <Replicate user>
LIST on TABLE to <Replicate user>

Schema privileges

CREATE SCHEMA to <Replicate user>
LIST on SCHEMA to <Replicate user>

View privileges

SELECT on _T_DATABASE to <Replicate user>
SELECT on _V_SCHEMA to <Replicate user>
SELECT on _V_USER to <Replicate user>
SELECT on _V_TABLE to <Replicate user>
SELECT on _V_TABLE_DIST to <Replicate user>
SELECT on _V_RELATION_KEYDATA to <Replicate user>
LIST on _T_DATABASE to <Replicate user>
LIST on _V_SCHEMA to <Replicate user>
LIST on _V_USER to <Replicate user>
LIST on _V_TABLE to <Replicate user>
LIST on _V_TABLE_DIST to <Replicate user>
LIST on _V_RELATION_KEYDATA to <Replicate user>

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here